Click Here!
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96

Bookmark It

Search this book:
 
Table of Contents


Appendix C
Flowcharts

This appendix contains a few flowcharts to refresh your memory about some of the topics and procedures discussed in this book.

Problem-Solving Methodology

The flowchart in Figure C.1 represents the problem-solving methodology presented in Chapter 4, “Tuning Methodology.” Here are some of the key points:

Analyze the Problem This step involves understanding what the issues are, if any. You may determine that there is no problem.
Determine the Cause Look into what is causing the problem you are experiencing. It is not always obvious.
Determine a Solution In this step, you determine a course of action and set expectations. It may be that you expect that your solution won’t fix the problem, but determining the solution always provides you with valuable information.
Test the Solution In this step, you test your assumptions and try a fix.
Analyze the Result In this step, you determine the success or failure of your solution. It may be that a failure to fix the problem is the expected result but that it provides good information about the cause of the problem.


Figure C.1  The problem-solving methodology flowchart.

User-Transaction Profile

The flowchart in Figure C.2 represents the user-transaction profile presented in Chapter 24, “What Is a Well-Tuned Statement?”


Figure C.2  The user-transaction profile.

SQL Statement Processing

The flowchart in Figure C.3 is the same flowchart presented in Chapter 24. It shows the steps taken to process SQL statements.


Figure C.3  SQL statement processing flowchart.

The Oracle Optimizer

The flowchart in Figure C.4 represents the workings of the Oracle optimizer as described in Chapter 27, “Using the Oracle Optimizer.”


Figure C.4  The Oracle optimizer.


Table of Contents


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc.
All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. Read EarthWeb's privacy statement.